1. Open the spread sheet in excel (you will see a bunch of divided by 0 errors, don't panic)

2. put cursor in upper left cell

3. go to "data" tab of excel

4. choose the "from text" button

5. in the browse window that opens, change file type to "all Files"

6. find your attendance.ini file in the DKP Scribe directory

7. in the dialog that opens choose "delimited" and hit next

8. in the next dialog choose "comma" and hit finish

9. hit ok. The data should show in the spread sheet.

10. to add a second attendance.ini file, (for larger guilds) go to the left most cell directly below the last player name and repeat steps 4-9

11. enter the plat amount to split in the cell with the box around it under where it says "enter plat amount"

12. this spreadsheet figures the split based on all of the previous 32 raid days. These days are shown as either a 1 (present) 0 (absent) or x (excused absence) you will need to remove all the entries that you don't need. Just hilite all the cells to the left of the days you want calculated and hit delete.
e.g. if you want the split based on the last 10 raid days, count back 10 spaces from cell 1:AH, and delete all data from cells to the left of that cell for every player. (in the case of 10 raids it would be all cells to the left of cell X)  Note: dont delete player names as that will make it dificult to figure out who to give the plat to.


13. you should now see the amount of plat each player gets to the right of their imported data in the green cell.